@ECHO OFF
set /p SQLSERVER= Give the SQL Server instance name?

CD .\TableCreationScripts
SQLCMD -S %SQLSERVER% -E -d IvyDB -i Ivy_CallAllTableCreationScripts.SQLCMD
CD ..\

CD .\StoredProcedureScripts
SQLCMD -S %SQLSERVER% -E -d IvyDB -i Ivy_CallAllStoredProcScripts.SQLCMD
CD ..\

PAUSE
@ECHO ON